View Single Post
 
Old 07-11-2019, 02:50 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

The formula is entered as conditional formatting rule condition, not into worksheet cell! Select the range with data (e.g. A3:A12), then activate Home menu, select Conditional Formatting and then New Rule (or when some rules are defined, then Manage Rules). For new rule select Use a Formula ... - and now enter the condition formula for left topmost cell of selection (be aware of use $ signs for cell references - in your case it must be $CR, like $E3). Then click Format and set there how cell is displayed when the condition is TRUE, and press OK until done!
Reply With Quote