LinkBack URL
About LinkBacksI have 2 fields A1 and B1
If B1 is blank I want the text in A1 to turn red. Otherwise it will remain
black.
Later if B1 is filled in then A1 will turn back to it's original state
(black).
How do I do this?
I have 2 fields A1 and B1
If B1 is blank I want the text in A1 to turn red. Otherwise it will remain
black.
Later if B1 is filled in then A1 will turn back to it's original state
(black).
How do I do this?
use Conditional Formatting.
1. Select cell A1.
2. On the menu bar select Format\Conditional Formatting
3. Select "Formula Is" from the first drop down on the left
4. Enter the Formula =ISBLANK(B1) into the text box to the right
5. Click "Format" and under the Font tab choose Color and select Red.
6. Click OK and OK
Originally Posted by savbci
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Your after conditional formatting.
Slect A1 then go to Format > conditional formatting. Click format and enter the below. Format font to red
=$B1=""
VBA Noob
You can use conditional formating (menu Format) in A1, set the condition with
"Formula Is" and use the following formula:
=ISBLANK(B1)
Then set the format as you want it in the Format button.
Hope this helps,
Miguel.
"savbci" wrote:
> I have 2 fields A1 and B1
> If B1 is blank I want the text in A1 to turn red. Otherwise it will remain
> black.
> Later if B1 is filled in then A1 will turn back to it's original state
> (black).
> How do I do this?
>
There are currently 2 users browsing this thread. (0 members and 2 guests)
Posting Permissions
Register To Reply
Bookmarks