hello
I can never get this to work
if column D = 0 I want column E and F to change colour (white so it appears to be blank
please see attahed
cheers
hello
I can never get this to work
if column D = 0 I want column E and F to change colour (white so it appears to be blank
please see attahed
cheers
Try in conditional formatting (CF)
=$D2=0
Font colour -- white
Applies to =$E$2:$F$11
Also, in Col. F your formula could read
=IF(D2=0,"",D2*E2)
And you wouldn't need any CF for Col. F
Life's a spreadsheet, Excel!
Say thanks, Click *
I agree, if you adjust teh formula, you wont need CF .
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks