Use this formula for conditional formatting
select column where you want to apply conditional formatting, enter formula and select fill color.
if your data in Column G...
=ISNUMBER(G5)
otherwise change the cell reference.
Use this formula for conditional formatting
select column where you want to apply conditional formatting, enter formula and select fill color.
if your data in Column G...
=ISNUMBER(G5)
otherwise change the cell reference.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks