ms office
I'm trying to highlight a cell based on another cell's data
Example:
A B
100% (green) 1
0% (red) 1 or greater
0% (white) 0
So I need to conditional column A so that if it shows 100% Green, 0% with a 1 or greater in B Red, and if it's 0% with a 0 in B white.
Any Ideas?
Format > Styles
There you can modify the styles in use for the current document, including hyperlink colours.
Found it! It's a setting under Preferences > Edit:
Extend data range formats and formulas
Misread it as "date ranges" on the first trawl through preferences. Turning it off stops this happening.
The comment about formulas seems to only mean that it doesn't fill empty cells with formulas when it thinks it's seen a pattern. After turning it off, it still does other automatic format adjustment e.g. incrementing formulas copied across a range:
Best Answer
Sounds like
Conditional Formatis what you are looking for.Select the cell which have to be formatted and choose
Format->Conditional Formatin the menu of Excel.For more information have a look at: use a formula to apply conditional formatting