Conditional formatting, with limitations.
June 2, 2012 9:12 AM Subscribe
How do I set conditional formatting in Excel based on whether a list value has been selected in a range of other cells?
posted by doyouknowwhoIam? to computers & internet (1 answer total)
I need to be able to format a header cell (B1, for example) based on whether or not other cells in that row have been filled in. The other cells will have a yes or no value in a drop-down menu, using the list function under Data, Validity. Snowflake issue: I'm using OpenOffice.org - calc. Ugh. Any ideas?