I want cell E42 to fill blue if n is entered into cell L4, but stay will no fill if y is entered into cell L4. I tried playing with the conditional format but can't seem to get the formula right.
I want cell E42 to fill blue if n is entered into cell L4, but stay will no fill if y is entered into cell L4. I tried playing with the conditional format but can't seem to get the formula right.
Select E42 apply conditional formatting
use a formula to determine which cells to format
enter this formula and select fill colour
=$L$4="n"
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks