If I have seven numbers in column A1:A7 and want them to all change font color if any one of them exceeds 100, how would I set a conditional format to accomplish this?
Thanks, Bill
If I have seven numbers in column A1:A7 and want them to all change font color if any one of them exceeds 100, how would I set a conditional format to accomplish this?
Thanks, Bill
Does anyone know what the proper forum would be for this question?
gregg11,
This is not a cross post since it was posted here 8 months prior to the one you cite.
On PC's it's:
=A1>100
applied to A1:A7
Last edited by protonLeah; 12-18-2016 at 04:35 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks