ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   color formula (https://www.excelbanter.com/excel-discussion-misc-queries/188773-color-formula.html)

Lisa

color formula
 
i am working on a spread sheet. i have set up that everytime i enter a number
the cell next to or two down adds 250 when i enter the first number is it
possible to make the cell with the added 250 turn red.

dksaluki

color formula
 
not completely sure i understand your question, but you could put in a
conditional format that basically says: "if this cell's value is more
that 250, turn red."

to do this, click the cell that you want to turn red. Then on the
main menu, click FORMAT CONDITIONAL FORMATTING...
Then set it to "Cell value is.....greater than....250". Then click
the format button and on the patterns tab, click the red color. clidk
OK..and OK

hope this helps,
dk


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com