How would I set/change the fill color of one cell of an Excel spreadsheet
based on the value of another cell on the same Excel spreadsheet?
How would I set/change the fill color of one cell of an Excel spreadsheet
based on the value of another cell on the same Excel spreadsheet?
Select the cell (say B1) and pull-down:
Format > Conditional Formatting... and pick formula is
=(A1="") and select you format (say fill red)
Then if A1 is empty, then B1 will show as red, otherwise not red.
--
Gary''s Student
"ForensicAccountant" wrote:
> How would I set/change the fill color of one cell of an Excel spreadsheet
> based on the value of another cell on the same Excel spreadsheet?
Using conditional formatting under the formatting menu. In the dialog,
change cell value is to Formula is and put in a formula that reacts to the
value in the other cell, producing True or False.
--
Regards,
Tom Ogilvy
"ForensicAccountant" <[email protected]> wrote in
message news:[email protected]...
> How would I set/change the fill color of one cell of an Excel spreadsheet
> based on the value of another cell on the same Excel spreadsheet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks