I am looking to have F5 remain white until D3 meets the criteria in which it will fill and populate the message similar to what is in F10 /F11.
I am looking to have F5 remain white until D3 meets the criteria in which it will fill and populate the message similar to what is in F10 /F11.
Last edited by ajamesritt; 12-01-2023 at 05:19 PM.
The text has to come from a formula, not conditional formatting. The color will come from conditional formatting.
What about F6? The example below shows F10 and F12 (not F11). You are merging cells there, usually a bad idea.
Please see the formulas I added in F5 and F6, and the two conditional formatting rules I added.
Thank you Sting Jazzer. This was exactly what I was looking for! Learning every day!
Glad to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks