I can't get the proper format for this.
If D5 is Yes
Then C5:C20 cells will be red
If D5 is No
Then C5:C20 will not change.
Thats All .. Thanks
I can't get the proper format for this.
If D5 is Yes
Then C5:C20 cells will be red
If D5 is No
Then C5:C20 will not change.
Thats All .. Thanks
Select C5
Conditional Formatting
New Rule
Use a formula to determine...
=(D$5="Yes")
format as red
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks for the help.
I was trying to write it out. Forgot string $
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks