how do i write a rule to apply the following conditional formatting:
as soon as any text is entered into a cell in one column, i want that whole row to change colour
thanks in advance!
how do i write a rule to apply the following conditional formatting:
as soon as any text is entered into a cell in one column, i want that whole row to change colour
thanks in advance!
Hi,
I have assumed you are entering text in column A.
1) Select your range which you want to highlight
2) Go to Conditional Formatting
3) New Rule
3) Use a Formula *
=ISTEXT($A1)
Click on format and set your desire format.
Hit Ok
Regards,
Khalid
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks