If i wanted to format a cell based on the formula ( =A1>"" ) in cell C1. How would i carry the conditional format down the entire C Column? Is this achievable in Conditional formatting or will this need to be VBA?
If i wanted to format a cell based on the formula ( =A1>"" ) in cell C1. How would i carry the conditional format down the entire C Column? Is this achievable in Conditional formatting or will this need to be VBA?
No dear not all,
Just follow below steps, after selecting the complete column
1 Click on Conditional Format Alt H, L, N
2 Select last value, Use formula to determine cell....
3 Paste your formula
4 do formatting as per your wish (change colour/ bg color etc)
*If you wish you click on *,a way to say ThankYou
What does the formula need to be if i want ( =A2>"" ) in cell C2, ( =A3>"" ) in cell C3, ( =A4>"" ) in cell C4 & so on. I cant use a table due to previous creator of WB other wise i would use =at symbolA>""
Sorry ID-10-T Error
Be aware that "" is a null text string
=a1>"" will ALWAYS return false if A contains a number ( XL evaluates the TYPE value before comparing)
Perhaps you need =A1<>""
Select your ranger in col C (starting in C1) and use =$A1<>"".
That's it, the CF will expand automatically
Hi,
Thats why we motivate and appreciate to include the sample file, so that if you are unable to write codes at least you have sample file to refer to.
Check the yellow banner above HOW TO ATTACH YOUR SAMPLE WORKBOOK:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks