GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Google Spreadsheet magic (https://gfy.com/showthread.php?t=1127513)

Sly	11-30-2013 05:11 PM

Google Spreadsheet magic

Let's say that I have a spreadsheet full of formulas. One of the formulas spits out a percentage. If the percentage is above 90%, I would like the cell to automatically fill green. If the percentage is 80%, I would like the cell to automatically fill yellow. If the percentage is 70%, I would like the cell to automatically fill pink.

Is this possible? What do I do?

CaptainWolfy

11-30-2013 05:19 PM

format > conditional formatting.. i think you can find out your way from there..

Sly	11-30-2013 05:23 PM

Quote:

Originally Posted by CaptainWolfy (Post 19891533)

format > conditional formatting.. i think you can find out your way from there..

That worked great. Thank you.

CaptainWolfy

11-30-2013 05:29 PM

Quote:

Originally Posted by Sly (Post 19891539)

That worked great. Thank you.

np, any time, glad i could help ;)

All times are GMT -7. The time now is 08:00 PM.