Microsoft Office Forums - View Single Post - Need conditional formatting formula

Thread: Need conditional formatting formula

View Single Post

Old

05-27-2016, 08:58 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Select B2:G2.
Click Conditional Formatting and select New Rule.
Select Use formula to determine .....
In the field Format values where this formula is true write: =$B$2<>"".
Click the Format and format as you wish.
OK.

Reply With Quote